Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 2969 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 301.7 KiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 2 |
qtde_products has a high cardinality: 2967 distinct values | High cardinality |
avg_recency_days has a high cardinality: 290 distinct values | High cardinality |
gross_revenue is highly correlated with qtde_invoices and 2 other fields | High correlation |
recency_days is highly correlated with qtde_invoices | High correlation |
qtde_invoices is highly correlated with gross_revenue and 2 other fields | High correlation |
qtde_items is highly correlated with gross_revenue and 2 other fields | High correlation |
avg_ticket is highly correlated with avg_unique_basket_size | High correlation |
avg_basket_size is highly correlated with gross_revenue and 1 other fields | High correlation |
avg_unique_basket_size is highly correlated with avg_ticket | High correlation |
gross_revenue is highly correlated with qtde_invoices and 1 other fields | High correlation |
qtde_invoices is highly correlated with gross_revenue and 1 other fields | High correlation |
qtde_items is highly correlated with gross_revenue and 1 other fields | High correlation |
avg_ticket is highly correlated with qtde_returns and 1 other fields | High correlation |
qtde_returns is highly correlated with avg_ticket and 1 other fields | High correlation |
avg_basket_size is highly correlated with avg_ticket and 1 other fields | High correlation |
gross_revenue is highly correlated with qtde_invoices and 1 other fields | High correlation |
qtde_invoices is highly correlated with gross_revenue and 1 other fields | High correlation |
qtde_items is highly correlated with gross_revenue and 2 other fields | High correlation |
avg_basket_size is highly correlated with qtde_items | High correlation |
gross_revenue is highly correlated with qtde_invoices and 4 other fields | High correlation |
qtde_invoices is highly correlated with gross_revenue and 1 other fields | High correlation |
qtde_items is highly correlated with gross_revenue and 4 other fields | High correlation |
avg_ticket is highly correlated with gross_revenue and 3 other fields | High correlation |
qtde_returns is highly correlated with gross_revenue and 3 other fields | High correlation |
avg_basket_size is highly correlated with gross_revenue and 3 other fields | High correlation |
avg_ticket is highly skewed (γ1 = 53.4442279) | Skewed |
qtde_returns is highly skewed (γ1 = 51.79774426) | Skewed |
avg_basket_size is highly skewed (γ1 = 44.68328098) | Skewed |
qtde_products is uniformly distributed | Uniform |
df_index has unique values | Unique |
customer_id has unique values | Unique |
recency_days has 34 (1.1%) zeros | Zeros |
qtde_returns has 1481 (49.9%) zeros | Zeros |
Reproduction
| Analysis started | 2022-07-29 13:42:28.506436 |
|---|---|
| Analysis finished | 2022-07-29 13:42:46.895998 |
| Duration | 18.39 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 2969 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2317.292354 |
| Minimum | 0 |
|---|---|
| Maximum | 5715 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 185.4 |
| Q1 | 929 |
| median | 2120 |
| Q3 | 3537 |
| 95-th percentile | 5035.2 |
| Maximum | 5715 |
| Range | 5715 |
| Interquartile range (IQR) | 2608 |
Descriptive statistics
| Standard deviation | 1554.944589 |
|---|---|
| Coefficient of variation (CV) | 0.6710178739 |
| Kurtosis | -1.010787014 |
| Mean | 2317.292354 |
| Median Absolute Deviation (MAD) | 1271 |
| Skewness | 0.342284058 |
| Sum | 6880041 |
| Variance | 2417852.674 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 3011 | 1 | < 0.1% |
| 2996 | 1 | < 0.1% |
| 2999 | 1 | < 0.1% |
| 3000 | 1 | < 0.1% |
| 3001 | 1 | < 0.1% |
| 3002 | 1 | < 0.1% |
| 3005 | 1 | < 0.1% |
| 3007 | 1 | < 0.1% |
| 3008 | 1 | < 0.1% |
| Other values (2959) | 2959 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 5715 | 1 | |
| 5696 | 1 | |
| 5686 | 1 | |
| 5680 | 1 | |
| 5659 | 1 | |
| 5655 | 1 | |
| 5649 | 1 | |
| 5638 | 1 | |
| 5637 | 1 | |
| 5627 | 1 |
| Distinct | 2969 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15270.77299 |
| Minimum | 12347 |
|---|---|
| Maximum | 18287 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 12347 |
|---|---|
| 5-th percentile | 12619.4 |
| Q1 | 13799 |
| median | 15221 |
| Q3 | 16768 |
| 95-th percentile | 17964.6 |
| Maximum | 18287 |
| Range | 5940 |
| Interquartile range (IQR) | 2969 |
Descriptive statistics
| Standard deviation | 1718.990292 |
|---|---|
| Coefficient of variation (CV) | 0.1125673398 |
| Kurtosis | -1.206094692 |
| Mean | 15270.77299 |
| Median Absolute Deviation (MAD) | 1488 |
| Skewness | 0.03160785866 |
| Sum | 45338925 |
| Variance | 2954927.624 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17850 | 1 | < 0.1% |
| 17588 | 1 | < 0.1% |
| 14905 | 1 | < 0.1% |
| 16103 | 1 | < 0.1% |
| 14626 | 1 | < 0.1% |
| 14868 | 1 | < 0.1% |
| 18246 | 1 | < 0.1% |
| 17115 | 1 | < 0.1% |
| 16611 | 1 | < 0.1% |
| 15912 | 1 | < 0.1% |
| Other values (2959) | 2959 |
| Value | Count | Frequency (%) |
| 12347 | 1 | |
| 12348 | 1 | |
| 12352 | 1 | |
| 12356 | 1 | |
| 12358 | 1 | |
| 12359 | 1 | |
| 12360 | 1 | |
| 12362 | 1 | |
| 12364 | 1 | |
| 12370 | 1 |
| Value | Count | Frequency (%) |
| 18287 | 1 | |
| 18283 | 1 | |
| 18282 | 1 | |
| 18277 | 1 | |
| 18276 | 1 | |
| 18274 | 1 | |
| 18273 | 1 | |
| 18272 | 1 | |
| 18270 | 1 | |
| 18269 | 1 |
| Distinct | 2954 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2749.226056 |
| Minimum | 6.2 |
|---|---|
| Maximum | 279138.02 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 6.2 |
|---|---|
| 5-th percentile | 229.77 |
| Q1 | 570.96 |
| median | 1086.92 |
| Q3 | 2308.06 |
| 95-th percentile | 7219.68 |
| Maximum | 279138.02 |
| Range | 279131.82 |
| Interquartile range (IQR) | 1737.1 |
Descriptive statistics
| Standard deviation | 10580.4905 |
|---|---|
| Coefficient of variation (CV) | 3.848534202 |
| Kurtosis | 353.9585684 |
| Mean | 2749.226056 |
| Median Absolute Deviation (MAD) | 672.72 |
| Skewness | 16.77787915 |
| Sum | 8162452.16 |
| Variance | 111946779.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 178.96 | 2 | 0.1% |
| 533.33 | 2 | 0.1% |
| 889.93 | 2 | 0.1% |
| 2053.02 | 2 | 0.1% |
| 745.06 | 2 | 0.1% |
| 379.65 | 2 | 0.1% |
| 2092.32 | 2 | 0.1% |
| 731.9 | 2 | 0.1% |
| 1353.74 | 2 | 0.1% |
| 331 | 2 | 0.1% |
| Other values (2944) | 2949 |
| Value | Count | Frequency (%) |
| 6.2 | 1 | |
| 13.3 | 1 | |
| 15 | 1 | |
| 36.56 | 1 | |
| 45 | 1 | |
| 52 | 1 | |
| 52.2 | 1 | |
| 52.2 | 1 | |
| 62.43 | 1 | |
| 68.84 | 1 |
| Value | Count | Frequency (%) |
| 279138.02 | 1 | |
| 259657.3 | 1 | |
| 194550.79 | 1 | |
| 168472.5 | 1 | |
| 140438.72 | 1 | |
| 124564.53 | 1 | |
| 117375.63 | 1 | |
| 91062.38 | 1 | |
| 72882.09 | 1 | |
| 66653.56 | 1 |
| Distinct | 272 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 64.28864938 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 34 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 11 |
| median | 31 |
| Q3 | 81 |
| 95-th percentile | 242 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 77.75617089 |
|---|---|
| Coefficient of variation (CV) | 1.209485215 |
| Kurtosis | 2.778038567 |
| Mean | 64.28864938 |
| Median Absolute Deviation (MAD) | 26 |
| Skewness | 1.798396863 |
| Sum | 190873 |
| Variance | 6046.022112 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 99 | 3.3% |
| 4 | 87 | 2.9% |
| 2 | 85 | 2.9% |
| 3 | 85 | 2.9% |
| 8 | 76 | 2.6% |
| 10 | 67 | 2.3% |
| 9 | 66 | 2.2% |
| 7 | 66 | 2.2% |
| 17 | 64 | 2.2% |
| 22 | 55 | 1.9% |
| Other values (262) | 2219 |
| Value | Count | Frequency (%) |
| 0 | 34 | 1.1% |
| 1 | 99 | |
| 2 | 85 | |
| 3 | 85 | |
| 4 | 87 | |
| 5 | 43 | |
| 7 | 66 | |
| 8 | 76 | |
| 9 | 66 | |
| 10 | 67 |
| Value | Count | Frequency (%) |
| 373 | 2 | |
| 372 | 4 | |
| 371 | 1 | < 0.1% |
| 368 | 1 | < 0.1% |
| 366 | 4 | |
| 365 | 2 | |
| 364 | 1 | < 0.1% |
| 360 | 1 | < 0.1% |
| 359 | 1 | < 0.1% |
| 358 | 4 |
| Distinct | 56 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.72280229 |
| Minimum | 1 |
|---|---|
| Maximum | 206 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 17 |
| Maximum | 206 |
| Range | 205 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 8.85665393 |
|---|---|
| Coefficient of variation (CV) | 1.547607882 |
| Kurtosis | 190.8253633 |
| Mean | 5.72280229 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 10.76645634 |
| Sum | 16991 |
| Variance | 78.44031883 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2 | 786 | |
| 3 | 498 | |
| 4 | 393 | |
| 5 | 237 | 8.0% |
| 1 | 190 | 6.4% |
| 6 | 173 | 5.8% |
| 7 | 138 | 4.6% |
| 8 | 98 | 3.3% |
| 9 | 69 | 2.3% |
| 10 | 55 | 1.9% |
| Other values (46) | 332 |
| Value | Count | Frequency (%) |
| 1 | 190 | 6.4% |
| 2 | 786 | |
| 3 | 498 | |
| 4 | 393 | |
| 5 | 237 | 8.0% |
| 6 | 173 | 5.8% |
| 7 | 138 | 4.6% |
| 8 | 98 | 3.3% |
| 9 | 69 | 2.3% |
| 10 | 55 | 1.9% |
| Value | Count | Frequency (%) |
| 206 | 1 | |
| 199 | 1 | |
| 124 | 1 | |
| 97 | 1 | |
| 91 | 2 | |
| 86 | 1 | |
| 72 | 1 | |
| 62 | 2 | |
| 60 | 1 | |
| 57 | 1 |
| Distinct | 1665 |
|---|---|
| Distinct (%) | 56.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1606.461098 |
| Minimum | 1 |
|---|---|
| Maximum | 196844 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 101.4 |
| Q1 | 296 |
| median | 639 |
| Q3 | 1399 |
| 95-th percentile | 4407.4 |
| Maximum | 196844 |
| Range | 196843 |
| Interquartile range (IQR) | 1103 |
Descriptive statistics
| Standard deviation | 5882.976527 |
|---|---|
| Coefficient of variation (CV) | 3.6620722 |
| Kurtosis | 467.153716 |
| Mean | 1606.461098 |
| Median Absolute Deviation (MAD) | 420 |
| Skewness | 17.87844459 |
| Sum | 4769583 |
| Variance | 34609412.81 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 310 | 11 | 0.4% |
| 88 | 9 | 0.3% |
| 150 | 9 | 0.3% |
| 260 | 8 | 0.3% |
| 84 | 8 | 0.3% |
| 288 | 8 | 0.3% |
| 272 | 8 | 0.3% |
| 246 | 8 | 0.3% |
| 516 | 7 | 0.2% |
| 394 | 7 | 0.2% |
| Other values (1655) | 2886 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 2 | |
| 12 | 2 | |
| 16 | 1 | |
| 17 | 1 | |
| 18 | 1 | |
| 19 | 1 | |
| 20 | 1 | |
| 23 | 1 | |
| 25 | 1 |
| Value | Count | Frequency (%) |
| 196844 | 1 | |
| 80997 | 1 | |
| 79963 | 1 | |
| 77373 | 1 | |
| 69993 | 1 | |
| 64549 | 1 | |
| 64124 | 1 | |
| 62812 | 1 | |
| 58243 | 1 | |
| 57785 | 1 |
| Distinct | 2967 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.3 KiB |
| 2123221231 | 2 |
|---|---|
| 85123A217332173385123A | 2 |
| 2068521524226914811648194481844818748173C82483824867147717091J7223272349B725861700322810228098248682483481872268771477 | 1 |
| 2173385123A21181218682153321080475662171482482224692247085099B475662285575049L85123A21080 | 1 |
| 230522305022766230532305121654220872267779030G23054230492305123053230502305223054226802268222683221702309222767230522305185123A221897281222676226792309222766230512165485032D84806B2305023052227662309290030A90030C22676226772267823323233272095623052 | 1 |
| Other values (2962) |
Length
| Max length | 39930 |
|---|---|
| Median length | 1493 |
| Mean length | 623.7325699 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1851862 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2965 ? |
|---|---|
| Unique (%) | 99.9% |
Sample
| 1st row | 85123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E2275222803217302263222633 |
|---|---|
| 2nd row | 848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049E |
| 3rd row | 22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094225402253922556225542255121981226152261622614162182232622492230072301021559210422108021086210942124021731223332233122556225542272922197220902249222991230092328023281225562249222434212402123822090227292072420719210392112121212211542098320981212458438023100212402123821244212422329822197212102235622466226102260922561227262272722728227291621823124210942108021086215592233322728210802109421086229552263622556359702198821989219872255422551220812208222080212102115621080210862109423445223262316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778221972336823367235062350922629215592115620750220902329822539233892235223389233882339022197207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298212122336723368223332299121094210862108021988219892198721680223322359823084235622254022544234802308423298229092261322617235152236721156223522155922326233882272822726 |
| 4th row | 22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012 |
| 5th row | 212582125821258 |
Common Values
| Value | Count | Frequency (%) |
| 2123221231 | 2 | 0.1% |
| 85123A217332173385123A | 2 | 0.1% |
| 2068521524226914811648194481844818748173C82483824867147717091J7223272349B725861700322810228098248682483481872268771477 | 1 | < 0.1% |
| 2173385123A21181218682153321080475662171482482224692247085099B475662285575049L85123A21080 | 1 | < 0.1% |
| 230522305022766230532305121654220872267779030G23054230492305123053230502305223054226802268222683221702309222767230522305185123A221897281222676226792309222766230512165485032D84806B2305023052227662309290030A90030C22676226772267823323233272095623052 | 1 | < 0.1% |
| 232052320185123A2198521212221782131422457229697274185169A211222112421986213858506621714213812249979302M847552241321181219772187021874226522283522112224082277985180B84510A22423227762197421671216722167021669216682208921381222952322720829848792247022670231472222485099F23201223862320021928219294819422469475662245785123A2072323204223562320522314700062240923472235312348423543849922121221985475662242385099B22376215772192821929207132238623201233432335684078A224412216922768219832198423378230848497823173226982269723175226992338223480234892352823529235232352723542223852266323343233442280922810229422294185048849457147723313 | 1 | < 0.1% |
| 223492230122300227492260622620226072260522998228992290422741227522097722821223842072822728227302296922993229072290522665223842320922273209692097022150221477147721912232292260522570225682311922493209722097122758227542275221935219342238223206207272238322961217912257022569221502214720972209692256422563227412072723209207252266723275221492260721914219152260522693227592256222632226332343922866228652286723493235042350322940221422214122144217312308422554225552255722568209692097020972209712263222633234392286622865228672211222835232092319822666231582294023082230832310023267233892348023084225682262120969209702349323494233552211422835221123597023100230832191422865228672255622554225572349323480217312308422112228352335523083 | 1 | < 0.1% |
| 71053220872208721340 | 1 | < 0.1% |
| 2250122776213404813871459847552242722844224234756622382223842238685099C2072585099B229072129423173226992317023245227202238422386224234756685123A2324323174231752243023582223868248690058B85099C2334490057 | 1 | < 0.1% |
| 21703230482304420972227492256822751230432304423091 | 1 | < 0.1% |
| Other values (2957) | 2957 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| charges | 6 | 0.2% |
| 2123221231 | 2 | 0.1% |
| 85123a217332173385123a | 2 | 0.1% |
| 2248775013b85123a8248375013b2276672802a72807a20828224878248422171824838248685213228002279172351b207672280622170213132245785123a82494l170032312010133207732076820774230822306582482101352082882494l725862248820828101352245722185824838248272351a217142171323462227682188922560224892191410135170032261922440233562148535471d221122262182494l8248272351b824838248321034 | 1 | < 0.1% |
| 221398485422411825672167222774227717127022262226372193421169211662117537444a37444c220862208384971s7127047580222618483222644215332155715056bl15056n226462217622438217312277822719215232262022778849462103384865211722150484563a84563b2250221867216722167337444a2277585035b22775843782263722891218992208382613b82599211582208685014a374462235521258793213744935004c84559b84997d4758084415b2065522170206772123922088220902090622262221752217621243220832109837444b2193422646373332121221872212598486584997d22086226208497884050212582290984997d84997c212442067521240215592289184946226444758021470227882276622261222622156372598225028248615056bl7932135004c82494l225022082922778228442264421731228452173185184c227742290922910824864000115056n228342075022788208292177421231207192072685035b793212080248173c2075082567848362167084849d229092284522746225632256222756219492124321245206772067484997d84997c84997b826002272321832223132244585136a7932148111222422271985099b35004c21668793212208721258221982217184997d84997c824838248615056bl84563a22891215592156121558223522165884509a2173121169223842209047580217732252385036a21988219892089782613c21899848322138021670216692167121672216732226221445214472143920675826002075020829223252156321564211212277521380222412177437449217732237821240212382106884970l84970s84989a2115521243212442124522909206752067422620207332112175049l8475521672216718248484947849468515284997c84997a84997d228052277121931223558248485099f2117582599207252072722384207282071920718207242067720675206742067684997b212422210384993a21244212432124521240212392123820676212122277422775227732277222845228442257182001s207272271921774218818248221754211642280521242206762108021212212388483621121218442264584970s15056n215582103521041475802075420718207242235615056n35004c79321227782284521658843782067622352216712167321669216702167284997d84997c2072521240210682123121210210802198921242212442124521243211232175485099f2071321930219282241121934217732072521668227742167021669216712167321754218992124321244220888259984997b84997d84997c84997a84509a84510a222622184472799f206752067720674206762156185099c85099f2071922356217312284437448221972206185232a2241184520b22088215592155884997c2165822494212442124521033215592156121558206752175485099b84997b84997d2217572760b2112222494215632156484997c84997a216732167221671216702166922774217312193415056n224942247021329213282132722262227752277421669216702290822908219892250279321215232208784509c84946213132067915056n222622217084970s22171474214742222470213272263722325227882082922313217332252185032b2138085019a2186721867214392289185163b1601621755848652155785167b848322211247559b4758021035848368437821658219472194921899215632156417136a2112121122206653733321166211698258182567825832227822276211632115984912b214702146784849d84971s84997c84997a2208922090220882075084596b84596f22176216732116421987219892068522646207282210321564217332112184378222622061884949211758515285014a15056n85014b851502155672760b84559b227522224185163b221712215122152221752231822170222472189984971s2167321672216712167020750215572277222241848368518722361223632236421122222622216272760b8520085150825992116915056bl15056n2217622318222428497822778227752166922774824862192820713207122193137444b37444a84849d2226222620851872145647590a2231885205b35920848362138917136a84997a22284215638248322121359242117584949227732155884849d2194784912a15056bl15056n219302211222291222762082985185b2216235637a215633592185163b85099c223522193121673226452072522087359242145615056n217552167222771228052228485205b21380226372226284997a84997d20829219492241147580215638483285188a223552217184509a22772216712167285185b2072684849d84832222812277020733211662132784510a2065585188a21470211102144522090208292235215056n222412175584865213292116985071d82567214702208621121219472188320655213802226220665210352192921928224112166821754400012071922719228442072479321216692072585099b2072784946212402067521244210332193182001s85099b82482213138497821314226632241122385222812111022613220882290822805227732175515056n825832082947590a2066585071d85071a84849d224182242084563a2147072799f8248421240215232067721243212442067521239211652116637444c37444a84750b84849d2198721121211222153782613a851872228184997a226632224182583824868248372760b79321212388497822364228452224175049l4742147590a2277122805206552123922325222628248384997a223182278815056n85014a21470215592217120725219312072622355216682208717129f21080215234818721558216722167021673216692271922774227722217122170213862229121169217312262085232a21755219342228185150211692143921380220902208922088225258518782483213142131385099b2193622101207282131375049l2121848173c4818548111481162124222197714598497822087824838248622104848328494621989225258515221755213802173320829206658437821035215578258184912a2209022321224112103385188a22291359212275221389215632156422771228052208782494l218844758021563215642252120829213802246722778849782271917129f219313744621035214702116622089225232065584997a85200213892229122525225582275522758227562275322754227578494982613c2138085188a215642275822757227562275522754227532198722243826002208885205b21171224112319923201232052320422661232052320823206851972228115056p2145921212216692167122355712792195582001s85099b2277522355223562072320724223832072622382223842072520727207282241121929226632193020711223852103321928223862193120712211758515222670231822267122672226752267422673850532245715056n15056p2144784563a2227882613a206558494922637226202262021731223322233122333223342209022089220882208722908213272132922281847892101221564220872075021928219292241120750221752156484997a221622215184949208292213922457219342319923201851522117584832226202186485014b15056bl15056n2208821931223844000320676206742072775049l84755849787145922386207122241185099f85099b227782167321672216702166921668217922266321211219882279620750218992140884997d21380227662217584997a21731231402314121115217332156321564211662116482600232564758015056n15056bl21557226372213921033223852192822457849782316885099b2193020711224272238685099f21931207192071221929226612238322382207182308484997c2319223191231902316523167231662237946138b2320621559221522156346138b232062241122178219312213921929223862266385099c85099f22386207122237921175712702186747590b22766226612071923208475802238315056n207282082920726207242072322356212452124284997a84997b232052320885099f22386207122192985099c84510a2320422383232012209084509a85099c23208231992238621929207272071220718228962071923205207262072385099f2325622382207282238422139216702308415056bl2275284692227572275822756232052235620724207232072620725219292103385099f85099b8497875049l17129f8248422774227722277121314227782316815056bl15056n84849d82613d826002227884997a84997c71270712702115922663211692275221467211152143984997b84997d22891227582155784970s20829213802173122382220832111548194226612072722663207192303423035230332242722103714772238217129f82001s20685232042071923206207282319923201224112238685099b21928219312189984596b84596f2111521166215562117121163213802173115056n15056bl22083826002156484347212312208321559224112193185099c2308923084217311600882001s21137227552275621787214472204121175211792116923182211942120815056n2067921557223162319247590a211242319623197231982242622278223158505384596f2328523286232872328818097c228912235447559b47580231992266385099b17091j2257122572210332238647590a2156321557227522111082613d17091j15056n206792173123201223852316623165231632242623182226712303520829220452167322548217902267022409224072240622408224072217921980219832198522615224682198221984219672261647310m2071221137160084811185159a85159b219302071185014b82613d22671208292121120898218672275622753227582275722754227552262022139231822215121447212328248622905229042290323197162252319223190229082178747351b2238675049l223602303322426230352308921716217152277371477227732277422041217182142821672216692290816225224672066584347229052116922671231822319823196231971600885014b15056n15056bl21671216682152348187231682303484569a84569d15056bl15056n20711219302071282600207262072421669216682167121670216722310417129f2113722467824862124585099f2192922775232062238322384207271600821731231822319647310m208292113721718217152318222316227552240923166231672319823197223152231615056bl71459207331600815056n15056bl22316231822277547310m22178231672267084970l2221922139214242142623198231962319723198217542240622409219862179121790226702178721930223862319985099c226702198222409217872247648173c15056bl22755211372131347310m82001s2316822197220412231648173c15056bl15056n85099b2267523201225482318272802a2213547351b1600823198712702121021424214272142822406217182171621467231672308922315223642277817129f213137147775049l8497847351b23168231652284482001s21137160082275215056bl15056n22620217552175448173c21934226372308922409214302240722408224104748047471217312267022665221512275722756227582275322754227552319823197231962267221447208292217421428228918256782600211752267521425214272290422905229032179021791225482254916225224062171822560222972198721439218672065584997d84997c84997a84997b221392293922990214702070479302m21989217152171622134231542210148173c221782235221470216692277385099c2316723166223862071322674226752232622328223272232922410227552233322411207122193021929219342267522670226732267415056n15056bl2303123029230322302822758217872082922646226452318446118214282217922326227212236223403219282192922663207112241121930207122217322682226832268022681226842268522670226792268622677226712267222673226782267684406b2314723146231482082922427227582232684949221322213379066k2318247563a84912a221398483220655213292189921327224292194723016215312264422637221792116621867209862250085014b85014a213802275221684231842153023142228982289921523230892242715056bl21791222162179022904230361622522644226462192920711211662227822674226912269222414223652236685014a206792316921110850531622523190231922319122754226202278144089c44089a8434721327213292231822085226712290421380226282257185099b79066k2238621928475802268622685226812233122406843472266321561215592113720713233152331623317214272241023026231632189222310215302264422646232752264522757219342268321427212573592422227231972275522686226852267622671218822188022326214702303184970l2120721166211652232715056bl8434784510a208292213984509a2316822467231662316585159b217747145948184231692208385099c22411207122268622676226702267722679226812302923032227582327522409218122318221086223322233315056n15056bl16008226632193421121226802267623032221712267715056p2331622366226202231085014b2132921791213272117422326227582198721881223312227621530227562188221812218112186421866230312275722162475802233222333212574818479302m4818522678226832314715056bl2173122326232752303122677226862268023148222972290521232217902236684600215302303221811227552213917091j211372121022686226782268322682226762267722685212588460084510a23275226208434715056bl208292267421731222278494784347215582314822663215302275821012229042213921094207132246822905226792275822755230322217521530224262104184510a23147226718434715056bl21755215312263722386219342319622758222272155822904843752173122161226822267722678843472240723169224672125884947211372275522758231682327548173c849472242616008225562319722572225712213921879218832188121880226202193422426229622296322227221392314716008843478248684510a22753227572138015056bl15056n23031231462241115056n15056bl21773227572181122904229052290322227226852268222683226782267622671226772268022670226812268422686226792267222754227562275322673226752267423163160082318222310211212188384375231462186722175851502116421169851522117521530224682217921211211642198821557226204742120679220652296322962211372316823166231672238620712227782213922844219342193021929219282131375049l84945847924811182483824822266385099c224112217182001s217312143915056p21987843472206582486206852222723271223332115947559b2082923397481872181184347218922314821812220782101222227223652242623168207112179122152215302275422753227562275723317233152250072800e160082184422227231962318422310217872267421880218822192822663221792082921892843752242920712220832316922467725982222735001g211101601621949218998483684347211694811684970s2067979302m8505321012233972236547563a21470214282082923026232752238685099c224114818821169207182072485099b223278469223031213808520285204852032319784347233162331522265207132279415056bl2204121169843472278123315233162275584971s442354423444235227582275523197226912113721258224142152448116231692331523316233172179022678222622189222227217182171623184231962193185099b84347224108494523147231482240647310m79302m22905461188497822752212582332621313481872331723197210122222722794231822175585053231102116921258231682316721314211374423484347 | 1 | < 0.1% |
| 22297227712277222773228052246922197211252112685049c85049d85049e85049g21061210632106284380843782296421213224172121284992219752238320728207272229620728207252072722383223842123222646223182072720728223832238423209207252264622645212312123223089231472314682486221972265022644224692219722469207272072822383232092193185099c2320385099b2192821929824868248385130b85130c2072522384235832330122383232092246922650221972309623452234532229720725 | 1 | < 0.1% |
| 22086229102283722730227278248484050226054811148188206852152322278217418517437343229042153121533210682107121523847542298522983226492153922072214982149921527374482224522693847552282722030232322323122501229262250222241229572228722699219222235422721226662292684879224422244322441212012290421218214072111622730227272260522697226982269922502225012242382484218447932121187475662111421925226912121021094210802108622333220902208722088220842208321202212042296475049l84380224372120721215231092229722927224432244121114231082260721917206852329823173226992269822697227252273022729227282272723283224568248485123a22501220372320823209232032320223046231702316821094220902208822083212122108621201212042120622197212132300022999226242272623244232352324521922225052272922728227252273022727793212242322781226052320822441224432269722699232452269885049g2317384755359702310122603226022321323209231122245622767227688248622766219168248479321219222290422026220302150622983226522317023175231742242722191227262272922730230572229622297227412256122083224182219723190210802299923000220902108621094217542111422725227272269922697226242260522441232088248322766227672320922698227262324521497232327147723075230462307022792230662306521916224568248422191227212266522666214072316885123a2317323109233502339323395234122335622467232432284322841235592269323196231972150622983229852354623545793212242382484714772323223109230702328323462233562266622665226052219121497217542245623112226992269823172231712317022727227262331122732233192208623381219802337922114233562335584029g23503230002299922436 | 1 | < 0.1% |
| 2211022098221002276622451225498474485049e213282296117091a2247384509a84510a22767227682146321464208208515022117211694812982580825788258122413219072244121122228518499122810228092243520966209632096122068217432174484709b2159221587209922266285123a228048248320749207252238220726223842246784625c84625a21108228482103347570b84030e22428225021621884559b84559a22437224368522722983220302119921829212942233222181222712227421989230532305216259475662329821034223542132640001851072332223321233332333423332224602298323109230822103423177851771623621703210982299723501235042350222621227552183223188230842207485049c1622585123a2214422910207582343423435233112340622766227282335282616c23044224912339523393233942278523569235702357184029g2147923319233188401223531227812348621034 | 1 | < 0.1% |
| 22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094225402253922556225542255121981226152261622614162182232622492230072301021559210422108021086210942124021731223332233122556225542272922197220902249222991230092328023281225562249222434212402123822090227292072420719210392112121212211542098320981212458438023100212402123821244212422329822197212102235622466226102260922561227262272722728227291621823124210942108021086215592233322728210802109421086229552263622556359702198821989219872255422551220812208222080212102115621080210862109423445223262316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778221972336823367235062350922629215592115620750220902329822539233892235223389233882339022197207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298212122336723368223332299121094210862108021988219892198721680223322359823084235622254022544234802308423298229092261322617235152236721156223522155922326233882272822726 | 1 | < 0.1% |
| 22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012 | 1 | < 0.1% |
| Other values (2963) | 2963 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 568777 | |
| 1 | 193850 | 10.5% |
| 3 | 182049 | 9.8% |
| 8 | 140316 | 7.6% |
| 9 | 133911 | 7.2% |
| 0 | 129867 | 7.0% |
| 4 | 125320 | 6.8% |
| 7 | 121703 | 6.6% |
| 5 | 121128 | 6.5% |
| 6 | 104084 | 5.6% |
| Other values (23) | 30857 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1821005 | |
| Uppercase Letter | 30846 | 1.7% |
| Space Separator | 11 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 8451 | |
| A | 7546 | |
| C | 3827 | |
| D | 2101 | 6.8% |
| L | 1834 | 5.9% |
| E | 1419 | 4.6% |
| F | 1252 | 4.1% |
| S | 1160 | 3.8% |
| G | 991 | 3.2% |
| P | 565 | 1.8% |
| Other values (12) | 1700 | 5.5% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 568777 | |
| 1 | 193850 | 10.6% |
| 3 | 182049 | 10.0% |
| 8 | 140316 | 7.7% |
| 9 | 133911 | 7.4% |
| 0 | 129867 | 7.1% |
| 4 | 125320 | 6.9% |
| 7 | 121703 | 6.7% |
| 5 | 121128 | 6.7% |
| 6 | 104084 | 5.7% |
Space Separator
| Value | Count | Frequency (%) |
| 11 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1821016 | |
| Latin | 30846 | 1.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 8451 | |
| A | 7546 | |
| C | 3827 | |
| D | 2101 | 6.8% |
| L | 1834 | 5.9% |
| E | 1419 | 4.6% |
| F | 1252 | 4.1% |
| S | 1160 | 3.8% |
| G | 991 | 3.2% |
| P | 565 | 1.8% |
| Other values (12) | 1700 | 5.5% |
Common
| Value | Count | Frequency (%) |
| 2 | 568777 | |
| 1 | 193850 | 10.6% |
| 3 | 182049 | 10.0% |
| 8 | 140316 | 7.7% |
| 9 | 133911 | 7.4% |
| 0 | 129867 | 7.1% |
| 4 | 125320 | 6.9% |
| 7 | 121703 | 6.7% |
| 5 | 121128 | 6.7% |
| 6 | 104084 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1851862 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 568777 | |
| 1 | 193850 | 10.5% |
| 3 | 182049 | 9.8% |
| 8 | 140316 | 7.6% |
| 9 | 133911 | 7.2% |
| 0 | 129867 | 7.0% |
| 4 | 125320 | 6.8% |
| 7 | 121703 | 6.6% |
| 5 | 121128 | 6.5% |
| 6 | 104084 | 5.6% |
| Other values (23) | 30857 | 1.7% |
| Distinct | 2966 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.90005685 |
| Minimum | 2.150588235 |
|---|---|
| Maximum | 56157.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 2.150588235 |
|---|---|
| 5-th percentile | 4.916661099 |
| Q1 | 13.11933333 |
| median | 17.97438356 |
| Q3 | 24.98828571 |
| 95-th percentile | 90.497 |
| Maximum | 56157.5 |
| Range | 56155.34941 |
| Interquartile range (IQR) | 11.86895238 |
Descriptive statistics
| Standard deviation | 1036.934336 |
|---|---|
| Coefficient of variation (CV) | 19.9794451 |
| Kurtosis | 2890.70744 |
| Mean | 51.90005685 |
| Median Absolute Deviation (MAD) | 5.994222271 |
| Skewness | 53.4442279 |
| Sum | 154091.2688 |
| Variance | 1075232.818 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 15 | 2 | 0.1% |
| 4.162 | 2 | 0.1% |
| 14.47833333 | 2 | 0.1% |
| 18.15222222 | 1 | < 0.1% |
| 13.92736842 | 1 | < 0.1% |
| 36.24411765 | 1 | < 0.1% |
| 29.78416667 | 1 | < 0.1% |
| 22.8792623 | 1 | < 0.1% |
| 20.51104167 | 1 | < 0.1% |
| 149.025 | 1 | < 0.1% |
| Other values (2956) | 2956 |
| Value | Count | Frequency (%) |
| 2.150588235 | 1 | |
| 2.4325 | 1 | |
| 2.462371134 | 1 | |
| 2.511241379 | 1 | |
| 2.515333333 | 1 | |
| 2.65 | 1 | |
| 2.656931818 | 1 | |
| 2.707598253 | 1 | |
| 2.760621572 | 1 | |
| 2.770464191 | 1 |
| Value | Count | Frequency (%) |
| 56157.5 | 1 | |
| 4453.43 | 1 | |
| 3202.92 | 1 | |
| 1687.2 | 1 | |
| 952.9875 | 1 | |
| 872.13 | 1 | |
| 841.0214493 | 1 | |
| 651.1683333 | 1 | |
| 640 | 1 | |
| 624.4 | 1 |
| Distinct | 290 |
|---|---|
| Distinct (%) | 9.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 23.3 KiB |
| 35 days | 49 |
|---|---|
| 14 days | 45 |
| 46 days | 43 |
| 21 days | 43 |
| 22 days | 43 |
| Other values (285) |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.127989222 |
| Min length | 6 |
Characters and Unicode
| Total characters | 21163 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 67 ? |
|---|---|
| Unique (%) | 2.3% |
Sample
| 1st row | 35 days |
|---|---|
| 2nd row | 27 days |
| 3rd row | 23 days |
| 4th row | 92 days |
| 5th row | 8 days |
Common Values
| Value | Count | Frequency (%) |
| 35 days | 49 | 1.7% |
| 14 days | 45 | 1.5% |
| 46 days | 43 | 1.4% |
| 21 days | 43 | 1.4% |
| 22 days | 43 | 1.4% |
| 38 days | 42 | 1.4% |
| 17 days | 41 | 1.4% |
| 27 days | 41 | 1.4% |
| 28 days | 41 | 1.4% |
| 26 days | 41 | 1.4% |
| Other values (280) | 2540 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| days | 2969 | |
| 35 | 49 | 0.8% |
| 14 | 45 | 0.8% |
| 46 | 43 | 0.7% |
| 21 | 43 | 0.7% |
| 22 | 43 | 0.7% |
| 38 | 42 | 0.7% |
| 17 | 41 | 0.7% |
| 27 | 41 | 0.7% |
| 28 | 41 | 0.7% |
| Other values (281) | 2581 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2969 | ||
| d | 2969 | |
| a | 2969 | |
| y | 2969 | |
| s | 2969 | |
| 1 | 1181 | 5.6% |
| 2 | 861 | 4.1% |
| 3 | 715 | 3.4% |
| 4 | 651 | 3.1% |
| 5 | 633 | 3.0% |
| Other values (5) | 2277 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 11876 | |
| Decimal Number | 6318 | |
| Space Separator | 2969 | 14.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1181 | |
| 2 | 861 | |
| 3 | 715 | |
| 4 | 651 | |
| 5 | 633 | |
| 6 | 513 | |
| 7 | 505 | |
| 9 | 437 | 6.9% |
| 8 | 429 | 6.8% |
| 0 | 393 | 6.2% |
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 2969 | |
| a | 2969 | |
| y | 2969 | |
| s | 2969 |
Space Separator
| Value | Count | Frequency (%) |
| 2969 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11876 | |
| Common | 9287 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2969 | ||
| 1 | 1181 | 12.7% |
| 2 | 861 | 9.3% |
| 3 | 715 | 7.7% |
| 4 | 651 | 7.0% |
| 5 | 633 | 6.8% |
| 6 | 513 | 5.5% |
| 7 | 505 | 5.4% |
| 9 | 437 | 4.7% |
| 8 | 429 | 4.6% |
Latin
| Value | Count | Frequency (%) |
| d | 2969 | |
| a | 2969 | |
| y | 2969 | |
| s | 2969 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21163 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2969 | ||
| d | 2969 | |
| a | 2969 | |
| y | 2969 | |
| s | 2969 | |
| 1 | 1181 | 5.6% |
| 2 | 861 | 4.1% |
| 3 | 715 | 3.4% |
| 4 | 651 | 3.1% |
| 5 | 633 | 3.0% |
| Other values (5) | 2277 |
frequency
Real number (ℝ≥0)
| Distinct | 1345 |
|---|---|
| Distinct (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07534240692 |
| Minimum | 0.005464480874 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 0.005464480874 |
|---|---|
| 5-th percentile | 0.009469702633 |
| Q1 | 0.01785714286 |
| median | 0.02949852507 |
| Q3 | 0.05555555556 |
| 95-th percentile | 0.2393929539 |
| Maximum | 6 |
| Range | 5.994535519 |
| Interquartile range (IQR) | 0.0376984127 |
Descriptive statistics
| Standard deviation | 0.2313970644 |
|---|---|
| Coefficient of variation (CV) | 3.071272526 |
| Kurtosis | 217.4065284 |
| Mean | 0.07534240692 |
| Median Absolute Deviation (MAD) | 0.01446093109 |
| Skewness | 12.28158046 |
| Sum | 223.6916062 |
| Variance | 0.05354460142 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.1428571429 | 21 | 0.7% |
| 0.3333333333 | 19 | 0.6% |
| 0.5 | 18 | 0.6% |
| 0.07142857143 | 17 | 0.6% |
| 0.03225806452 | 16 | 0.5% |
| 0.02857142857 | 15 | 0.5% |
| 0.1818181818 | 15 | 0.5% |
| 0.09523809524 | 15 | 0.5% |
| 0.04761904762 | 15 | 0.5% |
| 0.4 | 15 | 0.5% |
| Other values (1335) | 2803 |
| Value | Count | Frequency (%) |
| 0.005464480874 | 1 | < 0.1% |
| 0.005479452055 | 1 | < 0.1% |
| 0.005509641873 | 1 | < 0.1% |
| 0.005524861878 | 1 | < 0.1% |
| 0.005602240896 | 2 | |
| 0.005617977528 | 1 | < 0.1% |
| 0.005633802817 | 2 | |
| 0.005681818182 | 1 | < 0.1% |
| 0.005698005698 | 2 | |
| 0.005714285714 | 3 |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 3 | 3 | 0.1% |
| 2 | 11 | |
| 1.833333333 | 1 | < 0.1% |
| 1.5 | 1 | < 0.1% |
| 1.333333333 | 2 | 0.1% |
| 1 | 14 | |
| 0.75 | 1 | < 0.1% |
| 0.6666666667 | 12 |
| Distinct | 214 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 62.1569552 |
| Minimum | 0 |
|---|---|
| Maximum | 80995 |
| Zeros | 1481 |
| Zeros (%) | 49.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 9 |
| 95-th percentile | 100.6 |
| Maximum | 80995 |
| Range | 80995 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 1512.496135 |
|---|---|
| Coefficient of variation (CV) | 24.33349783 |
| Kurtosis | 2765.52864 |
| Mean | 62.1569552 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 51.79774426 |
| Sum | 184544 |
| Variance | 2287644.557 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1481 | |
| 1 | 164 | 5.5% |
| 2 | 148 | 5.0% |
| 3 | 105 | 3.5% |
| 4 | 89 | 3.0% |
| 6 | 78 | 2.6% |
| 5 | 61 | 2.1% |
| 12 | 51 | 1.7% |
| 8 | 43 | 1.4% |
| 7 | 43 | 1.4% |
| Other values (204) | 706 |
| Value | Count | Frequency (%) |
| 0 | 1481 | |
| 1 | 164 | 5.5% |
| 2 | 148 | 5.0% |
| 3 | 105 | 3.5% |
| 4 | 89 | 3.0% |
| 5 | 61 | 2.1% |
| 6 | 78 | 2.6% |
| 7 | 43 | 1.4% |
| 8 | 43 | 1.4% |
| 9 | 41 | 1.4% |
| Value | Count | Frequency (%) |
| 80995 | 1 | |
| 9014 | 1 | |
| 8004 | 1 | |
| 4427 | 1 | |
| 3768 | 1 | |
| 3332 | 1 | |
| 2878 | 1 | |
| 2022 | 1 | |
| 2012 | 1 | |
| 1776 | 1 |
avg_basket_size
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWED| Distinct | 1973 |
|---|---|
| Distinct (%) | 66.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 249.349541 |
| Minimum | 1 |
|---|---|
| Maximum | 40498.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 44 |
| Q1 | 103.25 |
| median | 172 |
| Q3 | 281.5 |
| 95-th percentile | 599.52 |
| Maximum | 40498.5 |
| Range | 40497.5 |
| Interquartile range (IQR) | 178.25 |
Descriptive statistics
| Standard deviation | 791.5024106 |
|---|---|
| Coefficient of variation (CV) | 3.174268569 |
| Kurtosis | 2256.245507 |
| Mean | 249.349541 |
| Median Absolute Deviation (MAD) | 82.75 |
| Skewness | 44.68328098 |
| Sum | 740318.7873 |
| Variance | 626476.066 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 100 | 11 | 0.4% |
| 114 | 10 | 0.3% |
| 73 | 9 | 0.3% |
| 86 | 9 | 0.3% |
| 82 | 9 | 0.3% |
| 136 | 8 | 0.3% |
| 60 | 8 | 0.3% |
| 75 | 8 | 0.3% |
| 88 | 8 | 0.3% |
| 71 | 7 | 0.2% |
| Other values (1963) | 2882 |
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 2 | 1 | |
| 3.333333333 | 1 | |
| 5.333333333 | 1 | |
| 5.666666667 | 1 | |
| 6.142857143 | 1 | |
| 7.5 | 1 | |
| 9 | 1 | |
| 9.5 | 1 | |
| 11 | 1 |
| Value | Count | Frequency (%) |
| 40498.5 | 1 | |
| 6009.333333 | 1 | |
| 4282 | 1 | |
| 3906 | 1 | |
| 3868.65 | 1 | |
| 2880 | 1 | |
| 2801 | 1 | |
| 2733.944444 | 1 | |
| 2518.769231 | 1 | |
| 2160.333333 | 1 |
| Distinct | 1010 |
|---|---|
| Distinct (%) | 34.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.15507374 |
| Minimum | 1 |
|---|---|
| Maximum | 299.7058824 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 23.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3.345454545 |
| Q1 | 10 |
| median | 17.2 |
| Q3 | 27.75 |
| 95-th percentile | 56.94 |
| Maximum | 299.7058824 |
| Range | 298.7058824 |
| Interquartile range (IQR) | 17.75 |
Descriptive statistics
| Standard deviation | 19.51303316 |
|---|---|
| Coefficient of variation (CV) | 0.8807478316 |
| Kurtosis | 27.69469772 |
| Mean | 22.15507374 |
| Median Absolute Deviation (MAD) | 8.2 |
| Skewness | 3.498252107 |
| Sum | 65778.41393 |
| Variance | 380.7584629 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 53 | 1.8% |
| 14 | 40 | 1.3% |
| 11 | 38 | 1.3% |
| 20 | 33 | 1.1% |
| 9 | 33 | 1.1% |
| 1 | 32 | 1.1% |
| 18 | 31 | 1.0% |
| 10 | 30 | 1.0% |
| 16 | 29 | 1.0% |
| 17 | 28 | 0.9% |
| Other values (1000) | 2622 |
| Value | Count | Frequency (%) |
| 1 | 32 | |
| 1.2 | 1 | < 0.1% |
| 1.25 | 1 | < 0.1% |
| 1.333333333 | 2 | 0.1% |
| 1.5 | 8 | 0.3% |
| 1.568181818 | 1 | < 0.1% |
| 1.571428571 | 1 | < 0.1% |
| 1.666666667 | 4 | 0.1% |
| 1.833333333 | 1 | < 0.1% |
| 2 | 24 |
| Value | Count | Frequency (%) |
| 299.7058824 | 1 | |
| 259 | 1 | |
| 203.5 | 1 | |
| 148 | 1 | |
| 145 | 1 | |
| 136.125 | 1 | |
| 135.5 | 1 | |
| 127 | 1 | |
| 122 | 1 | |
| 118 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | customer_id | gross_revenue | recency_days | qtde_invoices | qtde_items | qtde_products | avg_ticket | avg_recency_days | frequency | qtde_returns | avg_basket_size | avg_unique_basket_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 17850 | 5391.21 | 372.0 | 34.0 | 1733.0 | 85123A7105384406B84029G84029E22752217302263322632226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522173085123A7105384406B206793737021871210712106882483824868248282494L84029G84029E2275221730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105384406B206793737021871210712106882483824868248282494L84029G84029E227522280321730226322263385123A7105382483824868248282494L2241184029G84029E227522280321730226322263337370218712107121068824832241184029G84029E217302275285123A71053226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E21730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E2275221730226322263384029E22752228032173085123A7105384406B3737021871210712106882483824868248282494L2241184029G226322263385123A7105384406B3737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B15056BL206793737021871210712106882483824868248282494L2241184029G84029E227522280321730226322263385123A7105384406B373702187121071210688248282494L84029G84029E2275221730226332263285123A7105384406B15056BL2067937370210712106882483824868248282494L84029G84029E2275222803217302263222633 | 18.152222 | 35 days | 0.492958 | 40.0 | 50.970588 | 8.735294 |
| 1 | 1 | 13047 | 3232.59 | 56.0 | 9.0 | 1390.0 | 848792274522748227492231084969226232262221754217552177748187229602291322912229142175616161P227662270823231850158501622829227222296022961229692272022549209722274384969226222165821756217542175548184226922274822745227492296022722227202097222274849692262322499226072165847566217562175421755219022190121899219002207785123A2315223182231612316023163231622316423177231762300622996230702312623299849692165822423475662162123092231122311023111231182309323089231682323623240231752317323245230322303123029230288505322090220892208885123A217554756622423849692312620972227202315223162231632262316161P21754217552190121900481872311223111231102309323028232452324023173232362318223161231602296023546235452323122720227082298622739234352296022722227202097222621481884818448187230322303185053232452289922367235142351323511231982329423295230252347023397230962348723109234342208685049E | 18.904035 | 27 days | 0.048930 | 35.0 | 154.444444 | 19.000000 |
| 2 | 2 | 12583 | 6705.38 | 2.0 | 15.0 | 5028.0 | 22728227272272621724218831000221791210352232622629226592263122661217312290021913225402254422492210862108022726227272272822729211212232620750225512255622555217312239022333223312071921883210422236721094225402253922556225542255121981226152261622614162182232622492230072301021559210422108021086210942124021731223332233122556225542272922197220902249222991230092328023281225562249222434212402123822090227292072420719210392112121212211542098320981212458438023100212402123821244212422329822197212102235622466226102260922561227262272722728227291621823124210942108021086215592233322728210802109421086229552263622556359702198821989219872255422551220812208222080212102115621080210862109423445223262316922326224922103921210226592272622727227282233322466233282338823389233902337323374229912173122778221972336823367235062350922629215592115620750220902329822539233892235223389233882339022197207242348023570233672255522951224172197620719207242235622492226362219722083223262232821207227272272622728227302344523298212122336723368223332299121094210862108021988219892198721680223322359823084235622254022544234802308423298229092261322617235152236721156223522155922326233882272822726 | 28.902500 | 23 days | 0.045822 | 50.0 | 335.200000 | 15.466667 |
| 3 | 3 | 13748 | 948.25 | 95.0 | 5.0 | 439.0 | 22086228432284122839224232290722961225852208422423212322245722084233782312922423220772295023351233502331923354220868494622734229522301323012 | 33.866071 | 92 days | 0.017986 | 0.0 | 87.800000 | 5.600000 |
| 4 | 4 | 15100 | 876.00 | 333.0 | 3.0 | 80.0 | 212582125821258 | 292.000000 | 8 days | 0.139535 | 22.0 | 26.666667 | 1.000000 |
| 5 | 5 | 15291 | 4623.30 | 25.0 | 14.0 | 2102.0 | 22114217338248482486217542242422505227682175421755217562217084406B848792113685066227962229422487481884819420685847552162121623229682275922762217564818882486222412228848185215242242482486222192217084406B221732218948138481942152448111212322125984970L22855222122224121756206858248646000S222198487922189228222152348188847557147784970L22784216732167221669216682284422852228452285348184824862167221754217552166821669216702175521670216692166822578225792257721524481882173321754217552211222577225782257922784222122221923355 | 45.326471 | 23 days | 0.054598 | 29.0 | 150.142857 | 7.285714 |
| 6 | 6 | 14688 | 5630.87 | 7.0 | 21.0 | 3621.0 | 2238685099C210332072384997B84997C210942072521559223522121221975219778499184519A85183B85071B219312192922343223452234484519A48188223792238185099B2108021086219758499221210219742266784519B212162193521934219002191184849D2096671496B71495B2186521867219012186647310M218642186722090793212238122379219754811148173C2237921934223802235621900219012190222197207232072420719223552299622995229982299779302M7932147310M2237922381223802209021212461182193221937206752067621901219252193421935216212205348111223862072377101A2235677101A2143046126A2123921240212382124277101A22197210942198979321221792295320724223554611821937219362117248188231822318221034223812237948188219342197479026B22997229952189921900219022190123182219362123821866218642186521867217702117220676206772067579051A47310M2217922995229972318247310M220908482823298793212238023204229532193422356216212116521936211722235523205231822190282551825522267447310M22090793212193521934219372193621936219312238623199229532071923204217702320523182825512299622355223562177023199232012237979321215592072721930219342238685099B210332238622995229982238420728231822318222197211622116323321230802193021931223862320185099C85099F85099B231992238021934219352071920723223552320522356232042072420727207252238447310M21430793212117223321219012190021899219022295322997215582177022379219348255121935207112237921770231824611822995224672334822138217702299647310M2142722674221382261722379223812334820711221382334822467223812348523328217422246722467217702330120728231692358316258A8255221949231942324147310M23471218992190021901235011623621832162372355220986235712249123126231272227422475221912098285135C85136A2299722138214302319223182217542175621930235812238122379 | 17.219786 | 18 days | 0.073770 | 399.0 | 172.428571 | 15.571429 |
| 7 | 7 | 17809 | 5411.91 | 16.0 | 12.0 | 2057.0 | 229612294322617225692256884032B84032A227492294022909226522291022585215232262421523226244813823284232982298822366214632146422334210342233310120162352243921914212202132920974218292328423382229092295022910221412214223312225852296122561231882299122992231928469223300843478434723300231882214222141232982236623300 | 88.719836 | 35 days | 0.039216 | 41.0 | 171.416667 | 5.083333 |
| 8 | 8 | 15311 | 60767.90 | 0.0 | 91.0 | 38194.0 | 221398485422411825672167222774227717127022262226372193421169211662117537444A37444C220862208384971S7127047580222618483222644215332155715056BL15056N226462217622438217312277822719215232262022778849462103384865211722150484563A84563B2250221867216722167337444A2277585035B22775843782263722891218992208382613B82599211582208685014A374462235521258793213744935004C84559B84997D4758084415B2065522170206772123922088220902090622262221752217621243220832109837444B2193422646373332121221872212598486584997D22086226208497884050212582290984997D84997C212442067521240215592289184946226444758021470227882276622261222622156372598225028248615056BL7932135004C82494L225022082922778228442264421731228452173185184C227742290922910824864000115056N228342075022788208292177421231207192072685035B793212080248173C2075082567848362167084849D229092284522746225632256222756219492124321245206772067484997D84997C84997B826002272321832223132244585136A7932148111222422271985099B35004C21668793212208721258221982217184997D84997C824838248615056BL84563A22891215592156121558223522165884509A2173121169223842209047580217732252385036A21988219892089782613C21899848322138021670216692167121672216732226221445214472143920675826002075020829223252156321564211212277521380222412177437449217732237821240212382106884970L84970S84989A2115521243212442124522909206752067422620207332112175049L8475521672216718248484947849468515284997C84997A84997D228052277121931223558248485099F2117582599207252072722384207282071920718207242067720675206742067684997B212422210384993A21244212432124521240212392123820676212122277422775227732277222845228442257182001S207272271921774218818248221754211642280521242206762108021212212388483621121218442264584970S15056N215582103521041475802075420718207242235615056N35004C79321227782284521658843782067622352216712167321669216702167284997D84997C2072521240210682123121210210802198921242212442124521243211232175485099F2071321930219282241121934217732072521668227742167021669216712167321754218992124321244220888259984997B84997D84997C84997A84509A84510A222622184472799F206752067720674206762156185099C85099F2071922356217312284437448221972206185232A2241184520B22088215592155884997C2165822494212442124521033215592156121558206752175485099B84997B84997D2217572760B2112222494215632156484997C84997A216732167221671216702166922774217312193415056N224942247021329213282132722262227752277421669216702290822908219892250279321215232208784509C84946213132067915056N222622217084970S22171474214742222470213272263722325227882082922313217332252185032B2138085019A2186721867214392289185163B1601621755848652155785167B848322211247559B4758021035848368437821658219472194921899215632156417136A2112121122206653733321166211698258182567825832227822276211632115984912B214702146784849D84971S84997C84997A2208922090220882075084596B84596F22176216732116421987219892068522646207282210321564217332112184378222622061884949211758515285014A15056N85014B851502155672760B84559B227522224185163B221712215122152221752231822170222472189984971S2167321672216712167020750215572277222241848368518722361223632236421122222622216272760B8520085150825992116915056BL15056N2217622318222428497822778227752166922774824862192820713207122193137444B37444A84849D2226222620851872145647590A2231885205B35920848362138917136A84997A22284215638248322121359242117584949227732155884849D2194784912A15056BL15056N219302211222291222762082985185B2216235637A215633592185163B85099C223522193121673226452072522087359242145615056N217552167222771228052228485205B21380226372226284997A84997D20829219492241147580215638483285188A223552217184509A22772216712167285185B2072684849D84832222812277020733211662132784510A2065585188A21470211102144522090208292235215056N222412175584865213292116985071D82567214702208621121219472188320655213802226220665210352192921928224112166821754400012071922719228442072479321216692072585099B2072784946212402067521244210332193182001S85099B82482213138497821314226632241122385222812111022613220882290822805227732175515056N825832082947590A2066585071D85071A84849D224182242084563A2147072799F8248421240215232067721243212442067521239211652116637444C37444A84750B84849D2198721121211222153782613A851872228184997A226632224182583824868248372760B79321212388497822364228452224175049L4742147590A2277122805206552123922325222628248384997A223182278815056N85014A21470215592217120725219312072622355216682208717129F21080215234818721558216722167021673216692271922774227722217122170213862229121169217312262085232A21755219342228185150211692143921380220902208922088225258518782483213142131385099B2193622101207282131375049L2121848173C4818548111481162124222197714598497822087824838248622104848328494621989225258515221755213802173320829206658437821035215578258184912A2209022321224112103385188A22291359212275221389215632156422771228052208782494L218844758021563215642252120829213802246722778849782271917129F219313744621035214702116622089225232065584997A85200213892229122525225582275522758227562275322754227578494982613C2138085188A215642275822757227562275522754227532198722243826002208885205B21171224112319923201232052320422661232052320823206851972228115056P2145921212216692167122355712792195582001S85099B2277522355223562072320724223832072622382223842072520727207282241121929226632193020711223852103321928223862193120712211758515222670231822267122672226752267422673850532245715056N15056P2144784563A2227882613A206558494922637226202262021731223322233122333223342209022089220882208722908213272132922281847892101221564220872075021928219292241120750221752156484997A221622215184949208292213922457219342319923201851522117584832226202186485014B15056BL15056N2208821931223844000320676206742072775049L84755849787145922386207122241185099F85099B227782167321672216702166921668217922266321211219882279620750218992140884997D21380227662217584997A21731231402314121115217332156321564211662116482600232564758015056N15056BL21557226372213921033223852192822457849782316885099B2193020711224272238685099F21931207192071221929226612238322382207182308484997C2319223191231902316523167231662237946138B2320621559221522156346138B232062241122178219312213921929223862266385099C85099F22386207122237921175712702186747590B22766226612071923208475802238315056N207282082920726207242072322356212452124284997A84997B232052320885099F22386207122192985099C84510A2320422383232012209084509A85099C23208231992238621929207272071220718228962071923205207262072385099F2325622382207282238422139216702308415056BL2275284692227572275822756232052235620724207232072620725219292103385099F85099B8497875049L17129F8248422774227722277121314227782316815056BL15056N84849D82613D826002227884997A84997C71270712702115922663211692275221467211152143984997B84997D22891227582155784970S20829213802173122382220832111548194226612072722663207192303423035230332242722103714772238217129F82001S20685232042071923206207282319923201224112238685099B21928219312189984596B84596F2111521166215562117121163213802173115056N15056BL22083826002156484347212312208321559224112193185099C2308923084217311600882001S21137227552275621787214472204121175211792116923182211942120815056N2067921557223162319247590A211242319623197231982242622278223158505384596F2328523286232872328818097C228912235447559B47580231992266385099B17091J2257122572210332238647590A2156321557227522111082613D17091J15056N206792173123201223852316623165231632242623182226712303520829220452167322548217902267022409224072240622408224072217921980219832198522615224682198221984219672261647310M2071221137160084811185159A85159B219302071185014B82613D22671208292121120898218672275622753227582275722754227552262022139231822215121447212328248622905229042290323197162252319223190229082178747351B2238675049L223602303322426230352308921716217152277371477227732277422041217182142821672216692290816225224672066584347229052116922671231822319823196231971600885014B15056N15056BL21671216682152348187231682303484569A84569D15056BL15056N20711219302071282600207262072421669216682167121670216722310417129F2113722467824862124585099F2192922775232062238322384207271600821731231822319647310M208292113721718217152318222316227552240923166231672319823197223152231615056BL71459207331600815056N15056BL22316231822277547310M22178231672267084970L2221922139214242142623198231962319723198217542240622409219862179121790226702178721930223862319985099C226702198222409217872247648173C15056BL22755211372131347310M82001S2316822197220412231648173C15056BL15056N85099B2267523201225482318272802A2213547351B1600823198712702121021424214272142822406217182171621467231672308922315223642277817129F213137147775049L8497847351B23168231652284482001S21137160082275215056BL15056N22620217552175448173C21934226372308922409214302240722408224104748047471217312267022665221512275722756227582275322754227552319823197231962267221447208292217421428228918256782600211752267521425214272290422905229032179021791225482254916225224062171822560222972198721439218672065584997D84997C84997A84997B221392293922990214702070479302M21989217152171622134231542210148173C221782235221470216692277385099C2316723166223862071322674226752232622328223272232922410227552233322411207122193021929219342267522670226732267415056N15056BL2303123029230322302822758217872082922646226452318446118214282217922326227212236223403219282192922663207112241121930207122217322682226832268022681226842268522670226792268622677226712267222673226782267684406B2314723146231482082922427227582232684949221322213379066K2318247563A84912A221398483220655213292189921327224292194723016215312264422637221792116621867209862250085014B85014A213802275221684231842153023142228982289921523230892242715056BL21791222162179022904230361622522644226462192920711211662227822674226912269222414223652236685014A206792316921110850531622523190231922319122754226202278144089C44089A8434721327213292231822085226712290421380226282257185099B79066K2238621928475802268622685226812233122406843472266321561215592113720713233152331623317214272241023026231632189222310215302264422646232752264522757219342268321427212573592422227231972275522686226852267622671218822188022326214702303184970L2120721166211652232715056BL8434784510A208292213984509A2316822467231662316585159B217747145948184231692208385099C22411207122268622676226702267722679226812302923032227582327522409218122318221086223322233315056N15056BL16008226632193421121226802267623032221712267715056P2331622366226202231085014B2132921791213272117422326227582198721881223312227621530227562188221812218112186421866230312275722162475802233222333212574818479302M4818522678226832314715056BL2173122326232752303122677226862268023148222972290521232217902236684600215302303221811227552213917091J211372121022686226782268322682226762267722685212588460084510A23275226208434715056BL208292267421731222278494784347215582314822663215302275821012229042213921094207132246822905226792275822755230322217521530224262104184510A23147226718434715056BL21755215312263722386219342319622758222272155822904843752173122161226822267722678843472240723169224672125884947211372275522758231682327548173C849472242616008225562319722572225712213921879218832188121880226202193422426229622296322227221392314716008843478248684510A22753227572138015056BL15056N23031231462241115056N15056BL21773227572181122904229052290322227226852268222683226782267622671226772268022670226812268422686226792267222754227562275322673226752267423163160082318222310211212188384375231462186722175851502116421169851522117521530224682217921211211642198821557226204742120679220652296322962211372316823166231672238620712227782213922844219342193021929219282131375049L84945847924811182483824822266385099C224112217182001S217312143915056P21987843472206582486206852222723271223332115947559B2082923397481872181184347218922314821812220782101222227223652242623168207112179122152215302275422753227562275723317233152250072800E160082184422227231962318422310217872267421880218822192822663221792082921892843752242920712220832316922467725982222735001G211101601621949218998483684347211694811684970S2067979302M8505321012233972236547563A21470214282082923026232752238685099C224114818821169207182072485099B223278469223031213808520285204852032319784347233162331522265207132279415056BL2204121169843472278123315233162275584971S442354423444235227582275523197226912113721258224142152448116231692331523316233172179022678222622189222227217182171623184231962193185099B84347224108494523147231482240647310M79302M22905461188497822752212582332621313481872331723197210122222722794231822175585053231102116921258231682316721314211374423484347 | 25.543464 | 4 days | 0.316354 | 474.0 | 419.714286 | 26.142857 |
| 9 | 9 | 16098 | 2005.63 | 87.0 | 7.0 | 613.0 | 1000221912218322241122379223812279822726229262283922838227832292622782224112091422381206812269022730227282272722381223792241122926230942241184673B84673A21888230802238122992224112272622730227272272520914230942299222411150392091484077227282272923315233162273022725227262272722728227292272722730227252241122726227262191221888847542321523214 | 29.934776 | 47 days | 0.024476 | 0.0 | 87.571429 | 9.571429 |
Last rows
| df_index | customer_id | gross_revenue | recency_days | qtde_invoices | qtde_items | qtde_products | avg_ticket | avg_recency_days | frequency | qtde_returns | avg_basket_size | avg_unique_basket_size | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2959 | 5627 | 17727 | 1060.25 | 15.0 | 1.0 | 645.0 | 8505321928219292358123203229962300484978849462205122986232312354616156S215232269248187235972329822169221702309323408824822299047591D22965229892242522429224268505923243233372333523198219772330723295226242262722720232452297922980229782298122982229932349522722227232290723104225572255522556225512255423370233662143023236232402179022622 | 16.064394 | 6 days | 0.333333 | 6.0 | 645.000000 | 66.0 |
| 2960 | 5637 | 17232 | 421.52 | 2.0 | 2.0 | 203.0 | 843472148423356228162281823695220302077723439228662076620764228672286523494234932334422142229662208122991207612158421484843472357622144233192076123240224282286522726228672272723344 | 11.708889 | 12 days | 0.166667 | 0.0 | 101.500000 | 18.0 |
| 2961 | 5638 | 17468 | 137.00 | 10.0 | 2.0 | 116.0 | 2320422460212312259621070 | 27.400000 | 4 days | 0.500000 | 0.0 | 58.000000 | 2.5 |
| 2962 | 5649 | 13596 | 697.04 | 5.0 | 2.0 | 406.0 | 2262523345233462297823580231162285121136848422296184997A2236722899232752294921080232542171522450849922325622429223602329321877219758499123173220912327523289232902197223313233382296621592229552295122326218778498821034481872197523372229512241723296235752324123177235602334522630235082331322948224172295122630226292308423306232032339023494234932334323299227542290922910229032337122551235082248921878226232254921889225302254323320232852328823286232872308422534225442255623510233892294823598225632256222093227302340122111216152330722093234092337123241231932319421913230802242321888216212187822554226622238222499233902251622517225142251521715217182337284978231302244522450224462319723529216152319822489233722337123377849918497822485220912113622956232712246022178232452323922813231902274622748231772319423241232422179023367233462336823345 | 4.199036 | 7 days | 0.285714 | 0.0 | 203.000000 | 83.0 |
| 2963 | 5655 | 14893 | 1237.85 | 9.0 | 2.0 | 799.0 | 85183A2278220749222772193122380232022245722089216422331079302M2308222780230792231021314224232289422907229082227884912B2116717084N17091J2207522580235812149722438224392218170007217902170521703229602137722467229692110884031B84032B84032A84031A2236147421850662311085183B233532349285049A2290922818224568248485152825822117521174211812190821166219072315523200231992320385099F85099B23202 | 16.956849 | 2 days | 1.000000 | 0.0 | 399.500000 | 36.5 |
| 2964 | 5659 | 12479 | 473.20 | 11.0 | 1.0 | 382.0 | 21212212102108021086219892198721558212112121321882224378499222993226282121623243212172272021088219882109422215227342207785049E85049C20978209792097323370 | 15.773333 | 4 days | 0.375000 | 34.0 | 382.000000 | 30.0 |
| 2965 | 5680 | 14126 | 706.13 | 7.0 | 3.0 | 508.0 | 22274221502227322779226212245785123A2096122605224332147923444209632256020961 | 47.075333 | 3 days | 1.333333 | 50.0 | 169.333333 | 5.0 |
| 2966 | 5686 | 13521 | 1092.39 | 1.0 | 3.0 | 733.0 | 2353523301233002332022138228352211385177226512187823084851782262185039A21313219142145422620235702299323251218182181021819710502149435471D233272332621135230748497823367216842214422150218892179023189226592249484347216162162021615850592181821819221162117221905230602328121446234982342223420220912272784625A2301323014224812286322972229742332882551224022132985032A85032B85032C232932283122196210662299323293232942329521314224282218222961233682336523366235522349722196221952334023382230842259222842228402242922208222082220922211215342152821537359673596423163231622236747591D215922235222945232492325023251214942297722977210122348922071220702332022509223652277022605226072330123300219122254923526216192171384031B2067915056N229522211323356228352211122695221962295223295224242159284032B2339423396233952339321714233282353523536230892140121400233388498822190234942191422546851782318222673226712178721914210642255785231B232418505322118221192301923080848322308421718214942342222494840122329522642843752219621790219162212322942212792281122457224092240622398224002240021716224412296085061W2306023281234252241984707A22076220752247623169224742316935471D23328849472296423101231002341835970231682329522956234892263922642226382264323214218182181921810229562349523552234982349723296232932329523294212632250915056P20679206862217023084209922198421790235042209123376235062351022280222792295285176227272238923367225572255190214E2253022546225442254422533225342214422744227432349390214P90214I22651218782173921064207332198421705233002330122500216192308022940209722215085015150392262122500211152189121890220962275420996218942314421260213132138384993A848792113621718225222318985169A85169C85026B2249521494230742330922132220992339820986220972162085231B21976849918497822139214392267121172231882199321329235512110922119224732247422209224222339947469223982240223356221112283522113221102221022211222082144679063C22620231222163821640209752299322075220742207622481225632256222564222762207222109221082212484596B23252224752334022314229387000623368233662097522561229552247284819215912159284692359702264222343221962156322195215302197723123208682171522638226432321221162232812338223100218192181023212232152181021808218032295522956233202209422942 | 2.511241 | 4 days | 0.333333 | 0.0 | 244.333333 | 145.0 |
| 2967 | 5696 | 15060 | 301.84 | 8.0 | 4.0 | 262.0 | 22485224562346123090214942115484876B84877B215922199135471D85049A85049E235622298223100232752308422616229522125822597227342369485049A2202822209229522226635810B2161621619216158511185183A22500233952339422654231982235822507222782103485177233782261623376233782357117012D17012B2115485049E22734225858517685183A85049A225782257723359219912220922952222082337822597225782257785111226972346123090223782346185049E23354215922108022654231002327523352233512235823570221151625421616216152161935471D85032B223492234884877B84876B84876B2198085032C22754227552075520777223482339423395214282103422456206682245622030224022329123292234992191621991 | 2.515333 | 1 days | 4.000000 | 0.0 | 65.500000 | 30.0 |
| 2968 | 5715 | 12558 | 269.96 | 7.0 | 1.0 | 196.0 | 227122334485099B2320979191C233928482823158215072150822027 | 24.541818 | 6 days | 0.333333 | 196.0 | 196.000000 | 11.0 |